home *** CD-ROM | disk | FTP | other *** search
/ Power Programmierung / Power-Programmierung (Tewi)(1994).iso / magazine / dbms_mag / 9102 / gerrit3.feb < prev    next >
Text File  |  1990-12-17  |  245b  |  11 lines
  1. Listing 3
  2.  
  3. SELECT i#, idate FROM invoice
  4. WHERE c# IN (SELECT c# FROM customer
  5.                     WHERE name = 'Jones')
  6.  
  7. SELECT i#, idate FROM invoice
  8. WHERE c# = ANY (SELECT c# FROM customer
  9.                     WHERE name = 'Jones')
  10.  
  11.